Tabela PhP4TransactionHistory

Definicja tabeli PhP4TransactionHistory

Name

PhP4TransactionHistory

Code

PhP4TransactionHistory

Comment

PL: Transakcje P4 dziennik zmian


Lista kolumn tabeli PhP4TransactionHistory

Name

Code

TransactionID

TransactionID

ExternalID

ExternalID

Active

Active

Corrected

Corrected

TransactionCriteriaID

TransactionCriteriaID

CorrectionFor

CorrectionFor

StatusID

StatusID

TransactionHistoryID

TransactionHistoryID

Rev

Rev

RevTypeID

RevTypeID

TypeID

TypeID


Kolumna TransactionID tabeli PhP4TransactionHistory

Definicja kolumny TransactionID tabeli PhP4TransactionHistory

Name

TransactionID

Code

TransactionID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

identyfikator komunikatu


Kolumna ExternalID tabeli PhP4TransactionHistory

Definicja kolumny ExternalID tabeli PhP4TransactionHistory

Name

ExternalID

Code

ExternalID

Data Type

VARCHAR2(255)

Mandatory

No

Comment

identyfikator komunikatu zwrócony przez ZSMOPL


Kolumna Active tabeli PhP4TransactionHistory

Definicja kolumny Active tabeli PhP4TransactionHistory

Name

Active

Code

Active

Data Type

NUMBER(3)

Mandatory

Yes

Comment

 


Kolumna Corrected tabeli PhP4TransactionHistory

Definicja kolumny Corrected tabeli PhP4TransactionHistory

Name

Corrected

Code

Corrected

Data Type

NUMBER(10)

Mandatory

No

Comment

czy komunikat posiada korekte


Kolumna TransactionCriteriaID tabeli PhP4TransactionHistory

Definicja kolumny TransactionCriteriaID tabeli PhP4TransactionHistory

Name

TransactionCriteriaID

Code

TransactionCriteriaID

Data Type

NUMBER(10)

Mandatory

No

Comment

identyfikator kryteriów komunikatu


Kolumna CorrectionFor tabeli PhP4TransactionHistory

Definicja kolumny CorrectionFor tabeli PhP4TransactionHistory

Name

CorrectionFor

Code

CorrectionFor

Data Type

NUMBER(10)

Mandatory

No

Comment

identyfikator komunikatu korygowanego


Kolumna StatusID tabeli PhP4TransactionHistory

Definicja kolumny StatusID tabeli PhP4TransactionHistory

Name

StatusID

Code

StatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

obecny status komunikatu


Kolumna TransactionHistoryID tabeli PhP4TransactionHistory

Definicja kolumny TransactionHistoryID tabeli PhP4TransactionHistory

Name

TransactionHistoryID

Code

TransactionHistoryID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

identyfikator wpisu historycznego


Kolumna Rev tabeli PhP4TransactionHistory

Definicja kolumny Rev tabeli PhP4TransactionHistory

Name

Rev

Code

Rev

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna RevTypeID tabeli PhP4TransactionHistory

Definicja kolumny RevTypeID tabeli PhP4TransactionHistory

Name

RevTypeID

Code

RevTypeID

Data Type

NUMBER(3)

Mandatory

No

Comment

 


Kolumna TypeID tabeli PhP4TransactionHistory

Definicja kolumny TypeID tabeli PhP4TransactionHistory

Name

TypeID

Code

TypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID typu komunikatu wysylanego do ZSMOPL


Lista kluczy tabeli PhP4TransactionHistory

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PhP4TransactionHistory

Definicja klucza Identifier_1 tabeli PhP4TransactionHistory

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment